Select [GLMovement].[DBId] as [ResDBId], [GLMovement].[GLPeriodId] as [ResGLPeriodId], [GLMovement].[GLAccountId] as [ResGLAccountId], [GLMovement].[CurrencyId] as [ResCurrencyId], Round(Sum(Case When [GLMovement].[CD] = ‘D’ Then [GLMovement].[Amount] Else 0 End),2) as [ResCalcDTotal], Round(Sum(Case When [GLMovement].[CD] = ‘C’ Then [GLMovement].[Amount] Else 0 End),2) as [ResCalcCTotal], [GLYEBalance].[DTotal] as [ResDTotal], [GLYEBalance].[CTotal] as [ResCTotal]from (([GLMovement] LEFT JOIN [GLYEBalance]ON ([GLMovement].[DBId] = [GLYEBalance].[DBId]and [GLMovement].[GLPeriodId] = [GLYEBalance].[GLPeriodId]and [GLMovement].[GLAccountId] = … Continue reading Query: Verify GLYEBalance